Skip Headers

Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# $AGGMAP

The $AGGMAP property specifies the default AGGMAP type aggmap for a variable. This is the aggmap that Oracle OLAP uses when the variable is the target of an AGGREGATE command or AGGREGATE function that does not include a USING phrase.

When calculating the data in a variable, Oracle OLAP checks to see if the variable has an $AGGMAP property and, if it does, uses the aggmap object specified by that property as the default aggregation specification for a variable.

Syntax

You add or delete an $AGGMAP property to the most recently defined or considered object (see DEFINE and CONSIDER) using a PROPERTY statement:

- To add the property, issue the following statement.

  PROPERTY '$AGGMAP' agggmap-name

- To delete the property, issue the following statement.

  PROPERTY DELETE '$AGGMAP'

Arguments

aggmap-name

  A `TEXT` expression that is the name of a previously defined aggmap object.

Examples

Example 6-1 Using the $AGGMAP Property

Example 6-2, "Using the $AGGREGATE_FROM Property" illustrates how the AGGREGATE command shown in Example 6-28, "Using a CACHE Statement in an Aggregation Specification" can be simplified to the following statement.

    AGGREGATE sales_by_revenue USING revenue_aggmap

You can further simplify the AGGREGATE command if you place an $AGGMAP property on the `sales_by_revenue` variable. To define an $AGGMAP property on the `sales_by_revenue` variable, issue the following statements.

    CONSIDER sales_by_revenue
    PROPERTY ('$AGGMAP' 'revenue_aggmap')

Now you can aggregate the data by issuing the following AGGREGATE command that does not include a USING clause.

    AGGREGATE sales_by_revenue